SQL

Training classes videos

Validity

12 months

500

1 Introduction to SQL

Introduction to databases and their importance in organizing and storing data. Practice 0 / 3
Understanding the purpose of databases in various applications, from small-scale systems to large enterprises. Practice 0 / 3
Exploring different types of databases, such as relational databases (e.g., MySQL, PostgreSQL), NoSQL databases (e.g., MongoDB, Cassandra), and NewSQL databases. Practice 0 / 3
Introduction to SQL (Structured Query Language) as the standard language for interacting with databases. Practice 0 / 3
Overview of SQL syntax elements, including keywords, clauses, and statements. Practice 0 / 3
Explanation of essential SQL commands such as Select, INSERT, UPDATE, DELETE, and their usage in querying and manipulating data. Practice 0 / 3
Understanding data types and their significance in defining the structure of tables and columns in a database. Practice 0 / 3
Overview of common data types in SQL, including numeric data types (e.g., INTEGER, DECIMAL), character data types (e.g., VARCHAR, CHAR), date and time data types (e.g., DATE, TIMESTAMP), and boolean data type (e.g., BOOLEAN). Practice 0 / 3
Explanation of how data types determine the format and storage requirements of data values, and their impact on database performance and efficiency
DDL Statements

2 Retrieving Data with SELECT
3 Working with Data
4 Joins and Subqueries
5 Grouping and Aggregating Data
6 Data Manipulation Language (DML)
7 Introduction to PL/SQL
8 PL/SQL Control Structures
9 Exception Handling
10 Advanced PL/SQL Concepts
11 Overview of logical operators (e.g., AND, OR, NOT) for combining conditions and creating complex search criteria in SQL WHERE clauses.

Online Tests

#	Test Name	Type	Action
1	Case Study-1	FREE
2	Lab Assignment-1	FREE